﻿<?xml version="1.0" encoding="UTF-8"?>
<form xmlns="http://www.evolutility.com" title="客户产品价格信息" icon="cube.gif" description="">
  <data dbtable="MRP_CustomerProductDefinition" splogin="asp.net membership" dbwhere="PriceEndDate>getDate()" dbcolumnpk="ID" sppaging="EvoSP_PagedItem @SQLselect, @SQLtable, @SQLfrom, @SQLwhere, @SQLorderby, @SQLpk, @pageid, @pagesize" />
  <panel userid="1" ppos="1" label="MRP_CustomerProductDefinition" width="100">
    <field id="159" type="integer" typeid="10" label="Customerid" dbcolumn="CustomerID" dbcolumnread="CustomerID" maxlength="8" readonly="0" required="1" optional="" fpos="10" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="160" type="integer" typeid="10" label="Productid" dbcolumn="ProductID" dbcolumnread="ProductID" maxlength="8" readonly="0" required="1" optional="" fpos="20" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="161" type="decimal" typeid="9" label="Price" dbcolumn="Price" dbcolumnread="Price" maxlength="4" readonly="0" required="1" optional="" fpos="30" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="162" type="decimal" typeid="9" label="Maxprice" dbcolumn="MaxPrice" dbcolumnread="MaxPrice" maxlength="4" readonly="0" required="" optional="" fpos="40" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="163" type="decimal" typeid="9" label="Minprice" dbcolumn="MinPrice" dbcolumnread="MinPrice" maxlength="4" readonly="0" required="" optional="" fpos="50" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="164" type="decimal" typeid="9" label="Lastprice" dbcolumn="LastPrice" dbcolumnread="LastPrice" maxlength="4" readonly="0" required="" optional="" fpos="60" search="1" searchadv="1" searchlist="" height="1" width="20" />
    <field id="165" type="text" typeid="5" label="Modifieddate" dbcolumn="ModifiedDate" dbcolumnread="ModifiedDate" maxlength="1" readonly="0" required="" optional="" fpos="70" search="1" searchadv="1" searchlist="" height="1" width="20" />
    <field id="166" type="integer" typeid="10" label="State" dbcolumn="State" dbcolumnread="State" maxlength="8" readonly="0" required="" optional="" fpos="80" search="1" searchadv="1" searchlist="" height="1" width="20" />
    <field id="167" type="text" typeid="5" label="Statechangeddate" dbcolumn="StateChangedDate" dbcolumnread="StateChangedDate" maxlength="1" readonly="0" required="" optional="" fpos="90" search="1" searchadv="1" searchlist="" height="1" width="20" />
    <field id="168" type="text" typeid="5" label="Codeforcustomer" dbcolumn="CodeForCustomer" dbcolumnread="CodeForCustomer" maxlength="64" readonly="0" required="" optional="" fpos="100" search="1" searchadv="1" searchlist="" height="1" width="70" />

    <field id="146" panelid="1" type="lov" typeid="5" label="产品名称" dbcolumn="ProductID" dbcolumnread="Name" dbcolumnreadlov="Name" dbwherelov="MRP_MaterialMain.MType=5" dbtablelov="MRP_MaterialMain" maxlength="8" readonly="0" required="1" optional="" fpos="20" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="168" panelid="1" type="text" typeid="5" label="客户编号" dbcolumn="CodeForCustomer" dbcolumnread="CodeForCustomer" maxlength="64" readonly="0" required="" optional="" fpos="100" search="1" searchadv="1" searchlist="" height="1" width="70" />
    <field id="161" panelid="1" type="decimal" typeid="9" label="价格" dbcolumn="Price" dbcolumnread="Price" maxlength="4" readonly="0" required="1" optional="" fpos="30" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="38" panelid="1" type="lov" typeid="5" label="货币单位" dbcolumn="CurrencyType" dbcolumnread="ItemValue"
       dbtablelov="MRP_CommonLists" dbcolumnreadlov="DisplayText" dbwherelov="MRP_CommonLists.ListName='CurrencyCustomer'" maxlength="0" readonly="0" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="1" height="1" width="20" />

    <field id="38" panelid="1" type="lov" typeid="5" label="税金" dbcolumn="Tax" dbcolumnread="ItemValue"
   dbtablelov="MRP_CommonLists" dbcolumnreadlov="DisplayText" dbwherelov="MRP_CommonLists.ListName='TaxCustomer'" maxlength="0" readonly="0" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="1167" panelid="1" type="date" typeid="5" label="价格生效日" dbcolumn="PriceStartDate" dbcolumnread="PriceStartDate" maxlength="10" readonly="0" required="1" optional="" fpos="90" search="1" searchadv="1" searchlist="" height="1" width="20" />
    <field id="1168" panelid="1" type="date" typeid="5" label="价格失效日" dbcolumn="PriceEndDate" dbcolumnread="PriceEndDate" maxlength="10" readonly="0" required="1" optional="" fpos="90" search="1" searchadv="1" searchlist="" height="1" width="20" />

  </panel>

</form>
